﻿
--获取订单中指定项目的任务
CREATE PROCEDURE [dbo].[proc_Project_GetList_Task_ByPId]
	(
		@ProjectId uniqueidentifier
	)
AS
Begin
	Select id,Title
	,Rtrim((Case When ExecPersonName='' Then '['+Replace(Replace(ExecDepartmentName,'┆┄┄',''),'◆','')+']' Else ExecPersonName End)) As ExecPersonName
	,IsFinish
	From Project_Task p Where ProjectId=@ProjectId And ProductId In(select id from Product where flag=1)  --WebType>0
	Order By WebType,id
End